/*
 Navicat Premium Data Transfer

 Source Server         : 127.0.0.1
 Source Server Type    : MySQL
 Source Server Version : 50635
 Source Host           : 127.0.0.1
 Source Database       : BaseFrame

 Target Server Type    : MySQL
 Target Server Version : 50635
 File Encoding         : utf-8

 Date: 04/08/2018 16:20:45 PM
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `ArticleItems`
-- ----------------------------
DROP TABLE IF EXISTS `ArticleItems`;
CREATE TABLE `ArticleItems` (
  `Art_ID` varchar(37) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Art_Title` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '标题',
  `Art_RoadCode` char(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '路段编码',
  `Art_Label` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '类别ID',
  `Art_Imgs` text COLLATE utf8mb4_unicode_ci COMMENT '文章中的所有图片路径',
  `Art_SignImg_s` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '标志图 小图',
  `Art_SignImg_b` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '标志图 大图',
  `Art_Content` longtext COLLATE utf8mb4_unicode_ci COMMENT '内容',
  `Art_CreateTime` datetime DEFAULT NULL COMMENT '创建时间',
  `Art_ReadCount` int(11) DEFAULT NULL COMMENT '阅读数量',
  `Art_Intro` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '简介',
  `Art_AreaCode` char(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '所属区域',
  `Art_ArticleFrom` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '来路（TextBox）',
  `Art_ArticleFromCode` char(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '来路（用于统计）',
  `Art_UserID` int(11) DEFAULT '0' COMMENT '发布者ID',
  `Art_VideoPath` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '视频文件地址',
  `Art_IsRecommend` tinyint(1) DEFAULT '0' COMMENT '是否推荐',
  `Art_IsPreShowImg` tinyint(1) DEFAULT '0' COMMENT '是否把封面显示在图文信息前',
  `Art_ViewStyle` smallint(6) DEFAULT '0' COMMENT '视图样式',
  `Art_IsHide` smallint(6) DEFAULT '0' COMMENT '是否隐藏',
  PRIMARY KEY (`Art_ID`),
  KEY `Art_ArticleFromCode` (`Art_ArticleFromCode`),
  KEY `Art_Label` (`Art_Label`,`Art_AreaCode`,`Art_ArticleFromCode`),
  KEY `Art_IsRecommend` (`Art_IsRecommend`),
  KEY `Art_IsPreShowImg` (`Art_IsPreShowImg`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
--  Table structure for `ArticleItems_LabelCode`
-- ----------------------------
DROP TABLE IF EXISTS `ArticleItems_LabelCode`;
CREATE TABLE `ArticleItems_LabelCode` (
  `AR_ID` varchar(37) COLLATE utf8mb4_unicode_ci NOT NULL,
  `AR_LabelCode` char(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '分类编码',
  `AR_ArtID` varchar(37) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '图文信息ID',
  PRIMARY KEY (`AR_ID`),
  KEY `AR_ArtID` (`AR_ArtID`),
  KEY `AR_LabelCode_2` (`AR_LabelCode`,`AR_ArtID`),
  CONSTRAINT `articleitems_labelcode_ibfk_1` FOREIGN KEY (`AR_ArtID`) REFERENCES `ArticleItems` (`Art_ID`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
--  Table structure for `CarAdoptInfo`
-- ----------------------------
DROP TABLE IF EXISTS `CarAdoptInfo`;
CREATE TABLE `CarAdoptInfo` (
  `AC_ID` char(37) NOT NULL COMMENT '主键36位',
  `AC_CarNum` char(10) DEFAULT '' COMMENT '车牌号',
  `AC_CarType` char(10) DEFAULT '' COMMENT '车辆类别 ',
  `AC_CarWide` float DEFAULT '0' COMMENT '车宽（米）',
  `AC_CarLength` float DEFAULT '0' COMMENT '车长（米）',
  `AC_CarHeight` float DEFAULT '0' COMMENT '车高（米）',
  `AC_CarVolume` float DEFAULT '0' COMMENT '车辆体积（立方米）',
  `AC_CarWeight` float DEFAULT '0' COMMENT '车重（千克）',
  `AC_Tonnage` float DEFAULT NULL COMMENT '总重量（千克）',
  `AC_CarDensity` float DEFAULT '0' COMMENT '货物密度（t/m3）',
  `AC_CarImg` varchar(255) DEFAULT '' COMMENT '车辆图片名',
  `AC_GoodsImg` varchar(255) DEFAULT '' COMMENT '货物图片',
  `AC_InsertUseID` int(11) DEFAULT '0' COMMENT '采集人员id',
  `AC_AuditingType` int(2) DEFAULT '1' COMMENT '审核状态 0:全部，1:未审核，2：站长审核通过，3：中监站审核通过，4：站长审核未通过，5：中监站审核未通过',
  `AC_AuditWrongCause` varchar(255) DEFAULT '' COMMENT '审核不通过的原因',
  `AC_AuditWrongCauseRemark` varchar(255) DEFAULT '' COMMENT '审核失败的备注',
  `AC_AuditingMonitorID` varchar(20) DEFAULT NULL COMMENT '审核站长id',
  `AC_AuditingMasterID` varchar(20) DEFAULT NULL COMMENT '监控中心复查审核人员id',
  `AC_IsBlackCar` smallint(6) DEFAULT '0' COMMENT '是否是重点排查对象',
  `AC_OrgStructID` int(11) DEFAULT NULL COMMENT '组织结构id(站点id)',
  `AC_CargoType` varchar(200) DEFAULT NULL COMMENT '货物类别',
  `AC_Charges` decimal(10,2) DEFAULT '0.00' COMMENT '应收费金额',
  `AC_RealityCharges` decimal(10,2) DEFAULT '0.00' COMMENT '实收金额',
  `AC_Remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `AC_IsSealing` char(1) DEFAULT '0' COMMENT '是否封闭',
  `AC_IDPhoto` varchar(255) DEFAULT '' COMMENT '证件照',
  `AC_IsSync` smallint(1) DEFAULT '0' COMMENT '是否同步 （0：未同步，1：已同步）',
  `AC_IsOk` smallint(1) DEFAULT '1' COMMENT '数据是否正常（0：异常，1：正常）',
  `AC_EntryTime` int(11) DEFAULT '0' COMMENT '进站时间',
  `AC_ExportTime` int(11) DEFAULT '0' COMMENT '出站时间',
  `AC_CreateTime` int(11) DEFAULT '0' COMMENT '新增时间',
  `AC_AuditingTime` int(11) DEFAULT '0' COMMENT '审核时间',
  `AC_RepeatAuditionTime` int(11) DEFAULT '0' COMMENT '复审时间',
  `AC_Classes` varchar(4) DEFAULT '' COMMENT '班次 ：早班 中班 晚班',
  `AC_IntrySerialNum` varchar(50) DEFAULT '' COMMENT '入口流水号',
  `AC_IntryStationName` varchar(20) DEFAULT '' COMMENT '入口名称',
  `AC_IntryRoadName` varchar(255) DEFAULT '' COMMENT '入口路段名称',
  `AC_IntryCenterName` varchar(255) DEFAULT '' COMMENT '入口中心名称',
  `AC_ExportSerialNum` varchar(50) DEFAULT '' COMMENT '出口流水号',
  `AC_ExportStationName` varchar(255) DEFAULT '' COMMENT '出口名称',
  `AC_ExportRoadName` varchar(255) DEFAULT '' COMMENT '出口路段名称',
  `AC_ExportCenterName` varchar(255) DEFAULT '' COMMENT '出口分中心名称',
  `AC_Mileage` int(11) DEFAULT '0' COMMENT '计费里程',
  `AC_CarClass` varchar(255) DEFAULT '' COMMENT '车种',
  `AC_AbnormalType` char(255) DEFAULT '' COMMENT '异常类别',
  PRIMARY KEY (`AC_ID`),
  KEY `AC_CarNum` (`AC_CarNum`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;

-- ----------------------------
--  Records of `CarAdoptInfo`
-- ----------------------------
BEGIN;
INSERT INTO `CarAdoptInfo` VALUES ('062f8b8e-9547-4e80-a65a-b1a0a880f1a0', '云Q00000', '0101', '0', '0', '0', '0', '0', '0', '0', 'BB116538.jpg,8CF279D7.jpg,7387AFCA.jpg', '', '20', '1', '', '', '0', '0', '0', '1', '', '0.00', '0.00', '', '0', '', '0', '1', '0', '0', '1494322858', '0', '0', '中班', '', '', '', '', '', '', '', '', '0', '', ''), ('07e53c45-a6a4-45b7-a034-69e910d90d78', '云RTYUIO', '0101', '0', '0', '0', '0', '0', '0', '0', '10AA400F.jpg,7F7564E0.jpg,9C77BC45.jpg', '4D017C39.jpg', '20', '1', '', '', '0', '0', '0', '1', ',0201,0202,', '0.00', '0.00', '', '0', '98B233E1.jpg', '0', '1', '0', '0', '1493974050', '0', '0', '中班', '', '', '', '', '', '', '', '', '0', '', ',0101,0102,'), ('0c2c578a-09ae-460a-be18-d92af40fa7ab', '云TTTTTT', '0101', '0', '0', '0', '0', '0', '0', '0', '2A0049FF.jpg,2D3C3041.jpg,E70D5656.jpg', '', '20', '1', '', '', '0', '0', '0', '1', '', '0.00', '0.00', '', '0', '', '0', '1', '0', '0', '1494323081', '0', '0', '中班', '', '', '', '', '', '', '', '', '0', '', ''), ('2f7eb913-5c09-4d37-b8fe-de2fc59ff5c8', '云Q01234', '0101', '0', '0', '0', '0', '0', '0', '0', 'C9CAAA2B.jpg,F203D4E6.jpg,3074AF1A.jpg', '', '20', '2', '', '', '21', '0', '0', '1', ',0201,0202,', '0.00', '0.00', '', '0', '', '0', '1', '0', '0', '1494302189', '1494310351', '0', '早班', '', '', '', '', '', '', '', '', '0', '', ''), ('30b711e7-b5a1-44c9-89bf-124ebfc7d7f6', '云W00001', '0101', '0', '0', '0', '0', '0', '0', '0', '54D5245A.jpg,F439CA66.jpg,00535D52.jpg', 'F032E0F7.jpg', '20', '3', '', '', '21', '21', '0', '1', ',0101,', '0.00', '0.00', '', '0', '24AA948A.jpg', '0', '1', '0', '0', '1494209355', '1494238046', '1494238057', '早班', '', '', '', '', '', '', '', '', '0', '', ''), ('3baf7c6f-f205-4645-8c39-2a094468ec9a', '云Q00000', '0101', '0', '0', '0', '0', '0', '0', '0', '38C07618.jpg,D5EB37BA.jpg,828A70DA.jpg', '', '20', '2', '', '', '21', '0', '0', '1', ',0201,0202,', '0.00', '0.00', '测试', '0', '72DD5839.jpg', '0', '1', '0', '0', '1494301901', '1494310360', '0', '早班', '', '', '', '', '', '', '', '', '0', '', ',0104,'), ('50bcdf68-c2cf-4807-9d01-f397a2318baf', '云W98765', '0102', '0', '0', '0', '0', '0', '0', '0', '40F3EAE3.jpg,8881630B.jpg,8CF8FAC0.jpg', '', '20', '2', '', '', '21', '0', '0', '1', ',0202,', '0.00', '0.00', '', '0', '', '0', '1', '0', '0', '1494302808', '1494303935', '0', '早班', '', '', '', '', '', '', '', '', '0', '', ''), ('51f7c190-0c17-41ab-9a90-326512bdf55b', '云QWERRR', '0101', '0', '0', '0', '0', '0', '0', '0', 'EA18CE31.jpg,38E1BD2D.jpg,676FB85F.jpg', 'B050FEA7.jpg,3F854F1F.jpg,56D45AAA.jpg', '20', '1', '', '', '0', '0', '0', '1', ',0201,0202,', '0.00', '0.00', '呵呵呵呵呵呵呵呵地各地', '0', 'CA6B815F.jpg,D18A5749.jpg', '0', '1', '0', '0', '1494207354', '0', '0', '早班', '', '', '', '', '', '', '', '', '0', '', ',0104,0106,'), ('5a67df78-4489-48a0-9536-84c792d54188', '云WWEEEE', '0101', '0', '0', '0', '0', '0', '0', '0', '61EDA701.jpg,18608355.jpg,D6D6BB07.jpg', '', '20', '3', '', '', '21', '21', '0', '1', ',0201,0202,', '0.00', '0.00', '', '0', 'A7D5D2A0.jpg', '0', '1', '0', '0', '1494209068', '1494310372', '1494310395', '早班', '', '', '', '', '', '', '', '', '0', '', ''), ('5bb6a6f4-13ee-470f-beaa-b4adc248f6ca', '云QQQQQQ', '0103', '0', '0', '0', '0', '0', '0', '0', 'D1606FD5.jpg,874469B7.jpg,0518B3C7.jpg', '', '20', '4', '02,01', '', '21', '0', '0', '1', ',0101,', '0.00', '0.00', '', '0', '4E9AE75B.jpg', '0', '1', '0', '0', '1494212873', '1494238013', '0', '早班', '', '', '', '', '', '', '', '', '0', '', ''), ('630bef0f-947f-47bf-9f12-0eaff8112d83', '云RRRTTT', '0101', '0', '0', '0', '0', '0', '0', '0', '83FF26A6.jpg,1FE26D00.jpg,1BDD9EAC.jpg', '', '20', '2', '', '', '21', '0', '0', '1', '', '0.00', '0.00', '', '0', '', '0', '1', '0', '0', '1494303671', '1494303727', '0', '早班', '', '', '', '', '', '', '', '', '0', '', ''), ('978ac122-52b4-4bf6-bc61-f9b13c523147', '云QQQQQQ', '0101', '0', '0', '0', '0', '0', '0', '0', 'D00B7D71.jpg,2A70E0DC.jpg,1B4E4A0D.jpg,D76E1250.jpg,F3D44231.jpg,4E465C1A.jpg,05293655.jpg,BE5FE65E.jpg,2E139E7A.jpg', '', '20', '1', '', '', '0', '0', '0', '1', ',0201,0202,', '0.00', '0.00', '', '0', '48E24D24.jpg,F83C03CE.jpg,5FB07D4D.jpg', '0', '1', '0', '0', '1494208165', '0', '0', '早班', '', '', '', '', '', '', '', '', '0', '', ''), ('a0795bb0-3f43-4ed0-852f-84ed16f8c997', '云EERTTU', '0101', '0', '0', '0', '0', '0', '0', '0', '0DA8A38B.jpg,7DF7F35E.jpg,704C3225.jpg', '', '20', '1', '', '', '0', '0', '0', '1', '', '0.00', '0.00', '', '0', '', '0', '1', '0', '0', '1494322963', '0', '0', '中班', '', '', '', '', '', '', '', '', '0', '', ''), ('ac240024-b89f-496d-9e60-052c8417cb4f', '云Q00000', '0101', '0', '0', '0', '0', '0', '0', '0', '73B6F722.jpg,A90445FC.jpg,D8282AE9.jpg', '', '20', '2', '', '', '21', '0', '0', '1', '', '0.00', '0.00', '', '0', '', '0', '1', '0', '0', '1494303558', '1494303743', '0', '早班', '', '', '', '', '', '', '', '', '0', '', ''), ('da1ce837-88fc-46e6-ad52-968bdd9d699b', '云QOOOOO', '0101', '0', '0', '0', '0', '0', '0', '0', '20A4F57A.jpg,03BC752F.jpg,C0B355FC.jpg', '', '20', '3', '', '', '21', '21', '0', '1', ',0201,0202,', '0.00', '0.00', '', '0', '', '0', '1', '0', '0', '1494237541', '1494237608', '1494237983', '中班', '', '', '', '', '', '', '', '', '0', '', ',0103,0105,'), ('db76cd01-eb69-43ad-95b9-26c0c724c453', '云EEERRE', '0101', '0', '0', '0', '0', '0', '0', '0', '0A88DF54.jpg,C0539111.jpg,B08956B5.jpg', '', '20', '2', '', '', '21', '0', '0', '1', '', '0.00', '0.00', '', '0', '', '0', '1', '0', '0', '1494303804', '1494303869', '0', '早班', '', '', '', '', '', '', '', '', '0', '', ''), ('f45fb18e-cc34-4f35-bb2b-31bebb761b93', '云W12346', '0101', '0', '0', '0', '0', '0', '0', '0', '68B49F93.jpg,DF5D8444.jpg,EEF13343.jpg', '', '20', '2', '', '', '21', '0', '0', '1', ',0201,0202,', '0.00', '0.00', '', '0', 'FC468AFA.jpg', '0', '1', '0', '0', '1494302478', '1494302969', '0', '早班', '', '', '', '', '', '', '', '', '0', '', ',0104,'), ('f4a645cd-cc02-4164-a7e6-55bcba6b5b32', '云QQQQQQ', '0103', '0', '0', '0', '0', '0', '0', '0', '90054DA2.jpg,EE57E322.jpg,2DF9281E.jpg,F8F31EB5.jpg,F41C679E.jpg,1A8616A8.jpg,0B668CA4.jpg,3E4DE88D.jpg,238C5DF4.jpg,48ADEDB6.jpg,37BB1E71.jpg,DB334F62.jpg', '5DB4D494.jpg,C18370F2.jpg,8720E5C8.jpg,91AAED20.jpg', '20', '1', '', '', '0', '0', '0', '1', ',0101,', '0.00', '0.00', '', '0', '2C3FCED1.jpg,CAA99223.jpg,550B4003.jpg,68E49F1B.jpg', '0', '1', '0', '0', '1494208438', '0', '0', '早班', '', '', '', '', '', '', '', '', '0', '', '');
COMMIT;

-- ----------------------------
--  Table structure for `CarBlackInfo`
-- ----------------------------
DROP TABLE IF EXISTS `CarBlackInfo`;
CREATE TABLE `CarBlackInfo` (
  `CB_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `CB_CarNum` varchar(10) DEFAULT NULL COMMENT '车牌号',
  `CB_BlackReason` varchar(255) DEFAULT NULL COMMENT '进入黑名单原因',
  `CB_IsExamine` smallint(6) DEFAULT '0' COMMENT '是否已审核',
  `CB_SubmiterID` varchar(37) DEFAULT NULL COMMENT '提交人id',
  `CB_OperatorID` varchar(37) DEFAULT NULL COMMENT '审核人id',
  `CB_RunAwayCount` int(11) DEFAULT '0' COMMENT '偷逃次数',
  `CB_IllegalNum` int(11) DEFAULT '1' COMMENT '违规次数',
  `CB_OrgStructID` int(11) DEFAULT NULL COMMENT '组织架构id',
  `CB_CreactTime` datetime DEFAULT NULL COMMENT '加入黑名单时间',
  PRIMARY KEY (`CB_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;

-- ----------------------------
--  Records of `CarBlackInfo`
-- ----------------------------
BEGIN;
INSERT INTO `CarBlackInfo` VALUES ('18', '云FAY998', '逃费', '0', '1', '0', null, null, '13', '2017-04-13 11:49:08'), ('19', '云AFY766', '但事实上所所所所所所多所', '0', '1', '1', null, null, '1', '2017-04-13 17:45:21'), ('20', '云AFY765', '超载', '1', '18', '18', null, null, '6', '2017-04-19 15:55:15');
COMMIT;

-- ----------------------------
--  Table structure for `CarBlackRunawayLog`
-- ----------------------------
DROP TABLE IF EXISTS `CarBlackRunawayLog`;
CREATE TABLE `CarBlackRunawayLog` (
  `CBRL_ID` int(11) NOT NULL AUTO_INCREMENT,
  `CBRL_CarNum` varchar(10) DEFAULT NULL COMMENT '车牌号',
  `CBRL_Tollstation` int(11) DEFAULT '0' COMMENT '收费站',
  `CBRL_OrgStructID` int(11) DEFAULT '0' COMMENT '组织结构ID',
  `CBRL_SubmiterID` int(11) DEFAULT NULL COMMENT '添加记录者ID',
  `CBRL_CreateTime` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '记录创建时间',
  PRIMARY KEY (`CBRL_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;

-- ----------------------------
--  Records of `CarBlackRunawayLog`
-- ----------------------------
BEGIN;
INSERT INTO `CarBlackRunawayLog` VALUES ('43', '云AFY766', '9', '13', '1', '2017-04-13 20:53:39'), ('44', '云AFY766', '12', '5', '1', '2017-04-13 21:37:05'), ('45', '云AFY766', '6', '1', '1', '2017-04-14 10:01:33');
COMMIT;

-- ----------------------------
--  Table structure for `IframeConfig`
-- ----------------------------
DROP TABLE IF EXISTS `IframeConfig`;
CREATE TABLE `IframeConfig` (
  `ConfigKey` varchar(50) NOT NULL,
  `ConfigValue` text,
  `ConfigInfo` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`ConfigKey`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
--  Table structure for `IframeDict`
-- ----------------------------
DROP TABLE IF EXISTS `IframeDict`;
CREATE TABLE `IframeDict` (
  `zd_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '字典表',
  `zd_Name` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '名称',
  `zd_value` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '值',
  `zd_label` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '类型',
  `zd_sort` int(11) NOT NULL DEFAULT '0',
  `zd_ParentID` int(11) NOT NULL DEFAULT '0',
  `zd_IsParent` int(1) NOT NULL DEFAULT '0',
  `zd_IsShow` int(1) NOT NULL DEFAULT '1',
  `zd_Attr` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '属性',
  PRIMARY KEY (`zd_ID`),
  KEY `NewIndex1` (`zd_label`)
) ENGINE=InnoDB AUTO_INCREMENT=3871 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

-- ----------------------------
--  Records of `IframeDict`
-- ----------------------------
BEGIN;
INSERT INTO `IframeDict` VALUES ('11', '分类1', '001', null, '75', '0', '0', '1', null), ('12', '分类2', '002', null, '76', '0', '0', '1', null), ('3612', '绿通车', '01', 'Exception', '0', '0', '1', '1', ''), ('3613', '特殊车辆', '02', 'Exception', '2', '0', '1', '1', ''), ('3614', '超载', '0101', 'Exception', '0', '3612', '0', '1', ''), ('3615', '超高', '0102', 'Exception', '1', '3612', '0', '1', ''), ('3616', '超宽', '0103', 'Exception', '2', '3612', '0', '1', ''), ('3617', '无绿通证', '0104', 'Exception', '3', '3612', '0', '1', ''), ('3618', '行驶超时', '0105', 'Exception', '4', '3612', '0', '1', ''), ('3619', '车牌异常', '0106', 'Exception', '5', '3612', '0', '1', ''), ('3620', '无行驶证', '0107', 'Exception', '6', '3612', '0', '1', ''), ('3621', '该车逃费', '0108', 'Exception', '7', '3612', '0', '1', ''), ('3622', '出入口车牌不符', '0109', 'Exception', '8', '3612', '0', '1', ''), ('3623', '装载量不足', '0110', 'Exception', '9', '3612', '0', '1', ''), ('3624', '不配合检查', '0111', 'Exception', '10', '3612', '0', '1', ''), ('3625', '假冒绿通车', '0112', 'Exception', '11', '3612', '0', '1', ''), ('3626', '货特与货单不符', '0113', 'Exception', '12', '3612', '0', '1', ''), ('3627', '车型不符小改大', '0201', 'Exception', '4', '3613', '0', '1', ''), ('3628', 'U行免费', '0202', 'Exception', '3', '3613', '0', '1', ''), ('3629', '车种不符收改免', '0203', 'Exception', '2', '3613', '0', '1', ''), ('3630', '非正常超时', '0204', 'Exception', '1', '3613', '0', '1', ''), ('3631', '车型不符大改小（客车和货车）', '0205', 'Exception', '0', '3613', '0', '1', ''), ('3634', '2轴一型货', '0101', 'CarType', '0', '3653', '0', '1', '{“weight”:17.85}'), ('3635', '3轴二型货', '0102', 'CarType', '1', '3653', '0', '1', '{“weight”:26.25}'), ('3636', '4轴三型货', '0103', 'CarType', '2', '3653', '0', '1', '{“weight”:36.75}'), ('3637', '5轴四型货', '0104', 'CarType', '3', '3653', '0', '1', '{“weight”:45.15}'), ('3638', '6轴五型货', '0105', 'CarType', '4', '3653', '0', '1', '{“weight”:51.45}'), ('3653', '绿通车', '01', 'CarType', '0', '0', '1', '1', ''), ('3654', '特殊车辆', '02', 'CarType', '51', '0', '1', '1', ''), ('3655', 'U型超时车', '0201', 'CarType', '1', '3654', '0', '1', ''), ('3656', '超时车', '0202', 'CarType', '2', '3654', '0', '1', ''), ('3657', 'J型号车', '0203', 'CarType', '3', '3654', '0', '1', ''), ('3658', 'T型车', '0204', 'CarType', '4', '3654', '0', '1', ''), ('3659', '无卡车', '0205', 'CarType', '5', '3654', '0', '1', ''), ('3660', '坏卡车', '0206', 'CarType', '6', '3654', '0', '1', ''), ('3661', '超长车', '0207', 'CarType', '7', '3654', '0', '1', ''), ('3662', '拖车', '0208', 'CarType', '8', '3654', '0', '1', ''), ('3663', '油罐车', '0209', 'CarType', '9', '3654', '0', '1', ''), ('3664', '车流量', '01', 'StatisticsTarget', '52', '0', '1', '1', ''), ('3665', '柱状/条形图', 'bar', 'ChartType', '53', '0', '0', '1', ''), ('3666', '折线图', 'line', 'ChartType', '54', '0', '0', '1', ''), ('3667', '饼图', 'pie', 'ChartType', '55', '0', '0', '1', ''), ('3668', '统计方式', 'Category', 'StatisticsTarget', '1', '3664', '1', '1', ''), ('3669', '时间', 'DateTime', 'StatisticsTarget', '1', '3668', '0', '1', ''), ('3670', '车型', 'CarType', 'StatisticsTarget', '2', '3668', '0', '1', ''), ('3671', '数据分类', 'Legend', 'StatisticsTarget', '2', '3664', '1', '1', ''), ('3672', '车型', 'CarType', 'StatisticsTarget', '1', '3671', '0', '1', ''), ('3673', '货物分类', 'Goods', 'StatisticsTarget', '3', '3668', '0', '1', ''), ('3674', '异常分类', 'Exception', 'StatisticsTarget', '4', '3668', '0', '1', ''), ('3675', '货物分类', 'Goods', 'StatisticsTarget', '2', '3671', '0', '1', ''), ('3676', '异常情况', 'Exception', 'StatisticsTarget', '3', '3671', '0', '1', ''), ('3677', '货物吨位', '02', 'StatisticsTarget', '56', '0', '1', '1', ''), ('3678', '花卉类', '01', 'Goods', '57', '0', '1', '1', ''), ('3679', '蛋奶类', '02', 'Goods', '58', '0', '1', '1', ''), ('3680', '畜禽类', '03', 'Goods', '59', '0', '1', '1', ''), ('3681', '水产品类', '04', 'Goods', '60', '0', '1', '1', ''), ('3682', '菌类', '05', 'Goods', '61', '0', '1', '1', ''), ('3683', '昆虫类', '06', 'Goods', '62', '0', '1', '1', ''), ('3684', '鲜豆类', '07', 'Goods', '63', '0', '1', '1', ''), ('3685', '鲜活的畜禽及其幼苗', '0301', 'Goods', '1', '3680', '0', '1', ''), ('3686', '根茎块状水生蔬菜类', '08', 'Goods', '64', '0', '1', '1', ''), ('3687', '嫩茎叶苔花类', '09', 'Goods', '65', '0', '1', '1', ''), ('3688', '瓜类', '10', 'Goods', '66', '0', '1', '1', ''), ('3689', '茄果类', '11', 'Goods', '67', '0', '1', '1', ''), ('3690', '鲜果类', '12', 'Goods', '68', '0', '1', '1', ''), ('3691', '鲜切花', '0101', 'Goods', '1', '3678', '0', '1', ''), ('3692', '蛋', '0201', 'Goods', '1', '3679', '0', '1', ''), ('3693', '奶', '0202', 'Goods', '2', '3679', '0', '1', ''), ('3694', '新鲜水产品及其幼苗', '0401', 'Goods', '1', '3681', '0', '1', ''), ('3695', '人工种植食用菌', '0501', 'Goods', '1', '3682', '0', '1', ''), ('3696', '蜜蜂', '0601', 'Goods', '1', '3683', '0', '1', ''), ('3697', '荷兰豆', '0701', 'Goods', '1', '3684', '0', '1', ''), ('3698', '豆芽', '0702', 'Goods', '2', '3684', '0', '1', ''), ('3699', '毛豆', '0703', 'Goods', '3', '3684', '0', '1', ''), ('3700', '四季豆', '0704', 'Goods', '4', '3684', '0', '1', ''), ('3701', '豇豆', '0705', 'Goods', '5', '3684', '0', '1', ''), ('3702', '扁豆', '0706', 'Goods', '6', '3684', '0', '1', ''), ('3703', '青蚕豆', '0707', 'Goods', '7', '3684', '0', '1', ''), ('3704', '刀豆', '0708', 'Goods', '8', '3684', '0', '1', ''), ('3705', '青豌豆', '0709', 'Goods', '9', '3684', '0', '1', ''), ('3706', '四棱豆', '0710', 'Goods', '10', '3684', '0', '1', ''), ('3707', '胡萝卜', '0801', 'Goods', '1', '3686', '0', '1', ''), ('3708', '竹笋', '0802', 'Goods', '2', '3686', '0', '1', ''), ('3709', '芋', '0803', 'Goods', '3', '3686', '0', '1', ''), ('3710', '生姜', '0804', 'Goods', '4', '3686', '0', '1', ''), ('3711', '上药', '0805', 'Goods', '5', '3686', '0', '1', ''), ('3712', '洋姜', '0806', 'Goods', '6', '3686', '0', '1', ''), ('3713', '萝卜', '0807', 'Goods', '7', '3686', '0', '1', ''), ('3714', '百合', '0808', 'Goods', '8', '3686', '0', '1', ''), ('3715', '荸荠', '0809', 'Goods', '9', '3686', '0', '1', ''), ('3716', '茨菇', '0810', 'Goods', '10', '3686', '0', '1', ''), ('3717', '棕苞', '0811', 'Goods', '11', '3686', '0', '1', ''), ('3718', '藕', '0812', 'Goods', '12', '3686', '0', '1', ''), ('3719', '牛蒡', '0813', 'Goods', '13', '3686', '0', '1', ''), ('3720', '球茎甘蓝', '0814', 'Goods', '14', '3686', '0', '1', ''), ('3721', '芜箐', '0815', 'Goods', '15', '3686', '0', '1', ''), ('3722', '大蒜', '0816', 'Goods', '16', '3686', '0', '1', ''), ('3723', '洋葱', '0817', 'Goods', '17', '3686', '0', '1', ''), ('3724', '水芹', '0818', 'Goods', '18', '3686', '0', '1', ''), ('3725', '马铃薯', '0819', 'Goods', '19', '3686', '0', '1', ''), ('3726', '甘薯', '0820', 'Goods', '20', '3686', '0', '1', ''), ('3727', '鲜花生', '0821', 'Goods', '21', '3686', '0', '1', ''), ('3728', '甘蔗', '0822', 'Goods', '22', '3686', '0', '1', ''), ('3729', '竹笋', '0901', 'Goods', '1', '3687', '0', '1', ''), ('3730', '荠菜', '0902', 'Goods', '2', '3687', '0', '1', ''), ('3731', '芹菜', '0903', 'Goods', '3', '3687', '0', '1', ''), ('3732', '青蒜', '0904', 'Goods', '4', '3687', '0', '1', ''), ('3733', '莴苣', '0905', 'Goods', '5', '3687', '0', '1', ''), ('3734', '韭黄', '0906', 'Goods', '6', '3687', '0', '1', ''), ('3735', '结球甘蓝', '0907', 'Goods', '7', '3687', '0', '1', ''), ('3736', '白菜', '0908', 'Goods', '8', '3687', '0', '1', ''), ('3737', '芥菜', '0909', 'Goods', '9', '3687', '0', '1', ''), ('3738', '鱼腥草', '0910', 'Goods', '10', '3687', '0', '1', ''), ('3739', '花椰菜', '0911', 'Goods', '11', '3687', '0', '1', ''), ('3740', '葱', '0912', 'Goods', '12', '3687', '0', '1', ''), ('3741', '茭白', '0913', 'Goods', '13', '3687', '0', '1', ''), ('3742', '菜薹', '0914', 'Goods', '14', '3687', '0', '1', ''), ('3743', '朝鲜蓟', '0915', 'Goods', '15', '3687', '0', '1', ''), ('3744', '方芫荽', '0916', 'Goods', '16', '3687', '0', '1', ''), ('3745', '空心菜', '0917', 'Goods', '17', '3687', '0', '1', ''), ('3746', '落葵', '0918', 'Goods', '18', '3687', '0', '1', ''), ('3747', '豆苗', '0919', 'Goods', '19', '3687', '0', '1', ''), ('3748', '菜玉米', '0920', 'Goods', '20', '3687', '0', '1', ''), ('3749', '西洋菜', '0921', 'Goods', '21', '3687', '0', '1', ''), ('3750', '青菜', '0922', 'Goods', '22', '3687', '0', '1', ''), ('3751', '黄花菜', '0923', 'Goods', '23', '3687', '0', '1', ''), ('3752', '芥兰', '0924', 'Goods', '24', '3687', '0', '1', ''), ('3753', '罗勒', '0925', 'Goods', '25', '3687', '0', '1', ''), ('3754', '苋菜', '0926', 'Goods', '26', '3687', '0', '1', ''), ('3755', '芥蓝', '0927', 'Goods', '27', '3687', '0', '1', ''), ('3756', '蕨菜', '0928', 'Goods', '28', '3687', '0', '1', ''), ('3757', '茴香', '0929', 'Goods', '29', '3687', '0', '1', ''), ('3758', '韭菜', '0930', 'Goods', '30', '3687', '0', '1', ''), ('3759', '薄荷', '0931', 'Goods', '31', '3687', '0', '1', ''), ('3760', '芫荽', '0932', 'Goods', '32', '3687', '0', '1', ''), ('3761', '茼蒿', '0933', 'Goods', '33', '3687', '0', '1', ''), ('3762', '西芹', '0934', 'Goods', '34', '3687', '0', '1', ''), ('3763', '西兰花', '0935', 'Goods', '35', '3687', '0', '1', ''), ('3764', '香椿', '0936', 'Goods', '36', '3687', '0', '1', ''), ('3765', '油麦菜', '0937', 'Goods', '37', '3687', '0', '1', ''), ('3766', '蒜薹', '0938', 'Goods', '38', '3687', '0', '1', ''), ('3767', '山萮菜', '0939', 'Goods', '39', '3687', '0', '1', ''), ('3768', '草芽', '0940', 'Goods', '40', '3687', '0', '1', ''), ('3769', '菠菜', '0941', 'Goods', '41', '3687', '0', '1', ''), ('3770', '藜蒿', '0942', 'Goods', '42', '3687', '0', '1', ''), ('3771', '生菜', '0943', 'Goods', '43', '3687', '0', '1', ''), ('3772', '香菜', '0944', 'Goods', '44', '3687', '0', '1', ''), ('3773', '节瓜', '1001', 'Goods', '1', '3688', '0', '1', ''), ('3774', '佛手瓜', '1002', 'Goods', '2', '3688', '0', '1', ''), ('3775', '苦瓜', '1003', 'Goods', '3', '3688', '0', '1', ''), ('3776', '黄瓜', '1004', 'Goods', '4', '3688', '0', '1', ''), ('3777', '葫芦瓜', '1005', 'Goods', '5', '3688', '0', '1', ''), ('3778', '白瓜', '1006', 'Goods', '6', '3688', '0', '1', ''), ('3779', '菜瓜', '1007', 'Goods', '7', '3688', '0', '1', ''), ('3780', '青笋瓜', '1008', 'Goods', '8', '3688', '0', '1', ''), ('3781', '丝瓜', '1009', 'Goods', '9', '3688', '0', '1', ''), ('3782', '金瓜', '1010', 'Goods', '10', '3688', '0', '1', ''), ('3783', '冬瓜', '1011', 'Goods', '11', '3688', '0', '1', ''), ('3784', '南瓜', '1012', 'Goods', '12', '3688', '0', '1', ''), ('3785', '蛇瓜', '1013', 'Goods', '13', '3688', '0', '1', ''), ('3786', '瓠瓜', '1014', 'Goods', '14', '3688', '0', '1', ''), ('3787', '番茄', '1101', 'Goods', '1', '3689', '0', '1', ''), ('3788', '新鲜辣椒', '1102', 'Goods', '2', '3689', '0', '1', ''), ('3789', '茄子', '1103', 'Goods', '3', '3689', '0', '1', ''), ('3790', '芒果', '1201', 'Goods', '1', '3690', '0', '1', ''), ('3791', '柠檬', '1202', 'Goods', '2', '3690', '0', '1', ''), ('3792', '枇杷', '1203', 'Goods', '3', '3690', '0', '1', ''), ('3793', '葡萄', '1204', 'Goods', '4', '3690', '0', '1', ''), ('3794', '梅子', '1205', 'Goods', '5', '3690', '0', '1', ''), ('3795', '芭蕉', '1206', 'Goods', '6', '3690', '0', '1', ''), ('3796', '莲雾', '1207', 'Goods', '7', '3690', '0', '1', ''), ('3797', '红果', '1208', 'Goods', '8', '3690', '0', '1', ''), ('3798', '香蕉', '1209', 'Goods', '9', '3690', '0', '1', ''), ('3799', '苹果', '1210', 'Goods', '10', '3690', '0', '1', ''), ('3800', '草莓', '1211', 'Goods', '11', '3690', '0', '1', ''), ('3801', '火龙果', '1212', 'Goods', '12', '3690', '0', '1', ''), ('3802', '哈密瓜', '1213', 'Goods', '13', '3690', '0', '1', ''), ('3803', '番荔枝', '1214', 'Goods', '14', '3690', '0', '1', ''), ('3804', '荔枝', '1215', 'Goods', '15', '3690', '0', '1', ''), ('3805', '梨', '1216', 'Goods', '16', '3690', '0', '1', ''), ('3806', '石榴', '1217', 'Goods', '17', '3690', '0', '1', ''), ('3807', '酸刺', '1218', 'Goods', '18', '3690', '0', '1', ''), ('3808', '山竹', '1219', 'Goods', '19', '3690', '0', '1', ''), ('3809', '金桔', '1220', 'Goods', '20', '3690', '0', '1', ''), ('3810', '桃', '1221', 'Goods', '21', '3690', '0', '1', ''), ('3811', '无花果', '1222', 'Goods', '22', '3690', '0', '1', ''), ('3812', '西瓜', '1223', 'Goods', '23', '3690', '0', '1', ''), ('3813', '海棠', '1224', 'Goods', '24', '3690', '0', '1', ''), ('3814', '杨梅', '1225', 'Goods', '25', '3690', '0', '1', ''), ('3815', '樱桃', '1226', 'Goods', '26', '3690', '0', '1', ''), ('3816', '橘子', '1227', 'Goods', '27', '3690', '0', '1', ''), ('3817', '杏', '1228', 'Goods', '28', '3690', '0', '1', ''), ('3818', '枣', '1229', 'Goods', '29', '3690', '0', '1', ''), ('3819', '木瓜', '1230', 'Goods', '30', '3690', '0', '1', ''), ('3820', '菠萝蜜', '1231', 'Goods', '31', '3690', '0', '1', ''), ('3821', '人参果', '1232', 'Goods', '32', '3690', '0', '1', ''), ('3822', '菠萝', '1233', 'Goods', '33', '3690', '0', '1', ''), ('3823', '袖子', '1234', 'Goods', '34', '3690', '0', '1', ''), ('3824', '甜瓜', '1235', 'Goods', '35', '3690', '0', '1', ''), ('3825', '桂圆', '1236', 'Goods', '36', '3690', '0', '1', ''), ('3826', '橙子', '1237', 'Goods', '37', '3690', '0', '1', ''), ('3827', '李', '1238', 'Goods', '38', '3690', '0', '1', ''), ('3828', '番石榴', '1239', 'Goods', '39', '3690', '0', '1', ''), ('3829', '橄榄', '1240', 'Goods', '40', '3690', '0', '1', ''), ('3830', '柿子', '1241', 'Goods', '41', '3690', '0', '1', ''), ('3831', '桑葚', '1242', 'Goods', '42', '3690', '0', '1', ''), ('3832', '山楂', '1243', 'Goods', '43', '3690', '0', '1', ''), ('3833', '提子', '1244', 'Goods', '44', '3690', '0', '1', ''), ('3834', '猕猴桃', '1245', 'Goods', '45', '3690', '0', '1', ''), ('3835', '椰子', '1246', 'Goods', '46', '3690', '0', '1', ''), ('3836', '杨桃', '1247', 'Goods', '47', '3690', '0', '1', ''), ('3837', '伊丽莎白瓜', '1248', 'Goods', '48', '3690', '0', '1', ''), ('3838', '花菜士瓜', '1249', 'Goods', '49', '3690', '0', '1', ''), ('3839', '蓝莓', '1250', 'Goods', '50', '3690', '0', '1', ''), ('3840', '番木瓜', '1251', 'Goods', '51', '3690', '0', '1', ''), ('3844', '鲜玉米', '0711', 'Goods', '11', '3684', '0', '1', ''), ('3845', '统计方式', 'Category', 'StatisticsTarget', '1', '3677', '1', '1', ''), ('3846', '车型', 'CarType', 'StatisticsTarget', '1', '3845', '0', '1', ''), ('3847', '鲜肉', '0302', 'Goods', '2', '3680', '0', '1', ''), ('3848', '内脏', '0303', 'Goods', '3', '3680', '0', '1', ''), ('3849', '家兔', '0304', 'Goods', '4', '3680', '0', '1', ''), ('3850', '食用蛙类', '0305', 'Goods', '5', '3680', '0', '1', ''), ('3851', '早班', '早班', 'Classes', '69', '0', '0', '1', ''), ('3852', '中班', '中班', 'Classes', '70', '0', '0', '1', ''), ('3853', '晚班', '晚班', 'Classes', '71', '0', '0', '1', ''), ('3854', '中心', '01', 'OrgStructType', '72', '0', '0', '1', ''), ('3855', '收费站', '02', 'OrgStructType', '73', '0', '0', '1', ''), ('3856', '石锁高速', '石锁高速', 'RoadSection', '74', '0', '0', '1', ''), ('3857', '车牌照不清晰', '01', 'AdoptInfoAuditWrongCause', '0', '0', '0', '1', ''), ('3858', '所运货物未达到要求容积', '02', 'AdoptInfoAuditWrongCause', '1', '0', '0', '1', ''), ('3859', '前后车牌不一致', '03', 'AdoptInfoAuditWrongCause', '2', '0', '0', '1', ''), ('3860', '无车头或车尾车牌照片', '04', 'AdoptInfoAuditWrongCause', '3', '0', '0', '1', ''), ('3861', '所运货物照片不清晰', '05', 'AdoptInfoAuditWrongCause', '4', '0', '0', '1', ''), ('3862', '其他（手动填写原因）', '06', 'AdoptInfoAuditWrongCause', '8', '0', '0', '1', ''), ('3863', '与其它货物混装', '01014', 'Exception', '13', '3612', '0', '1', ''), ('3864', '有效容积率80％以下', '0115', 'Exception', '14', '3612', '0', '1', ''), ('3865', '与其它货物混装', '10', 'AdoptInfoAuditWrongCause', '5', '0', '0', '1', ''), ('3866', '低于承运车辆核定载质量', '11', 'AdoptInfoAuditWrongCause', '6', '0', '0', '1', ''), ('3867', '超限运输，超限5%以上', '12', 'AdoptInfoAuditWrongCause', '7', '0', '0', '1', ''), ('3868', '散装绿通产品无法开门查验', '0116', 'Exception', '15', '3612', '0', '1', ''), ('3869', '掩盖过于严实导致查验费时及困难', '0117', 'Exception', '16', '3612', '0', '1', ''), ('3870', '集装箱货车无法进行多点查验', '0118', 'Exception', '17', '3612', '0', '1', '');
COMMIT;

-- ----------------------------
--  Table structure for `IframeOrgStruct`
-- ----------------------------
DROP TABLE IF EXISTS `IframeOrgStruct`;
CREATE TABLE `IframeOrgStruct` (
  `OS_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `OS_Name` varchar(50) DEFAULT NULL COMMENT '组织结构名称',
  `OS_Type` char(10) DEFAULT NULL COMMENT '组织结构类型',
  `OS_Sort` int(11) DEFAULT NULL COMMENT '排序',
  `OS_IsParent` smallint(1) DEFAULT '0' COMMENT '是否是父级',
  `OS_IsShow` smallint(1) DEFAULT '1' COMMENT '是否可见',
  `OS_ParentID` int(11) DEFAULT NULL COMMENT '父级ID',
  `OS_CreateTime` datetime DEFAULT NULL COMMENT '创建时间',
  `OS_IsDel` smallint(1) DEFAULT '0',
  PRIMARY KEY (`OS_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;

-- ----------------------------
--  Records of `IframeOrgStruct`
-- ----------------------------
BEGIN;
INSERT INTO `IframeOrgStruct` VALUES ('1', '锁龙寺', '02', '5', '0', '0', '2', '2017-03-22 16:38:11', '0'), ('2', '弥勒南监控中心', '01', '0', '1', '0', '0', '2017-03-22 16:39:04', '0'), ('4', '中心-2', '01', '1', '1', '0', '0', '2017-03-27 12:09:36', '1'), ('5', '中心-3', '01', '3', '0', '0', '0', '2017-03-27 12:09:41', '1'), ('6', '石鹿阜', '02', '2', '0', '0', '2', '2017-03-27 12:09:52', '0'), ('7', '长湖2', '02', '3', '0', '0', '2', '2017-03-27 12:20:16', '0'), ('8', '弥勒北', '02', '1', '0', '0', '2', '2017-03-27 12:20:27', '0'), ('9', '收费站2-2', '02', '1', '0', '0', '4', '2017-03-27 12:44:15', '1'), ('10', '收费站2-1', '02', '0', '0', '0', '4', '2017-03-27 12:46:47', '1'), ('11', '早班', '', '1', '0', '0', '1', '2017-04-07 14:07:04', '1'), ('12', '弥勒南', '02', '4', '0', '0', '2', '2017-04-10 17:01:59', '0'), ('13', '竹园', '02', '0', '0', '0', '2', '2017-04-10 17:02:06', '0'), ('24', 'ddddd', '02', '6', '1', '1', '2', '2017-10-26 09:09:00', '1'), ('25', 'ddd', '01', '0', '0', '1', '24', '2017-10-26 09:09:06', '1'), ('26', 'ddd111', '01', '2', '0', '1', '1', '2017-10-26 09:09:25', '1');
COMMIT;

-- ----------------------------
--  Table structure for `IframeRule`
-- ----------------------------
DROP TABLE IF EXISTS `IframeRule`;
CREATE TABLE `IframeRule` (
  `RuleID` int(11) NOT NULL AUTO_INCREMENT,
  `RuleName` varchar(50) DEFAULT NULL,
  `RuleInfo` varchar(50) DEFAULT NULL,
  `RuleIsRecNotice_FirstTrial` smallint(255) DEFAULT '0' COMMENT '是否接收重点检测车辆审核通知',
  `RuleIsRecNotice_TwoTrial` smallint(255) DEFAULT '0' COMMENT '是否接收复审通知',
  `RuleIsRecBlackInfoNotice` smallint(255) DEFAULT '0' COMMENT 'RuleIsRecBlackInfoNotice',
  `RuleAble` text,
  `RuleOrgStructID` int(11) DEFAULT '0' COMMENT '组织结构ID',
  PRIMARY KEY (`RuleID`)
) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
--  Records of `IframeRule`
-- ----------------------------
BEGIN;
INSERT INTO `IframeRule` VALUES ('49', '站点', '', '0', '0', '0', '[{\"M\":271,\"A\":\"\"},{\"M\":270,\"A\":\"\"},{\"M\":274,\"A\":\"\"},{\"M\":275,\"A\":\"\"},{\"M\":279,\"A\":\"\"},{\"M\":294,\"A\":\"\"},{\"M\":295,\"A\":\"\"},{\"M\":296,\"A\":\"\"},{\"M\":297,\"A\":\"\"},{\"M\":298,\"A\":\"\"},{\"M\":308,\"A\":\"禁止编辑,禁止删除\"},{\"M\":309,\"A\":\"禁止导入数据\"},{\"M\":312,\"A\":\"禁止编辑,禁止删除\"},{\"M\":314,\"A\":\"\"},{\"M\":315,\"A\":\"\"},{\"M\":316,\"A\":\"\"}]', '2'), ('50', '中心', '', '0', '1', '0', '[{\"M\":4,\"A\":\"\"},{\"M\":7,\"A\":\"\"},{\"M\":264,\"A\":\"\"},{\"M\":265,\"A\":\"\"},{\"M\":266,\"A\":\"\"},{\"M\":271,\"A\":\"\"},{\"M\":270,\"A\":\"\"},{\"M\":274,\"A\":\"\"},{\"M\":275,\"A\":\"\"},{\"M\":279,\"A\":\"\"},{\"M\":281,\"A\":\"\"},{\"M\":283,\"A\":\"\"},{\"M\":284,\"A\":\"\"},{\"M\":285,\"A\":\"\"},{\"M\":294,\"A\":\"\"},{\"M\":295,\"A\":\"\"},{\"M\":296,\"A\":\"\"},{\"M\":297,\"A\":\"\"},{\"M\":298,\"A\":\"\"},{\"M\":307,\"A\":\"\"},{\"M\":308,\"A\":\"禁止编辑,禁止删除\"},{\"M\":309,\"A\":\"禁止导入数据\"},{\"M\":312,\"A\":\"禁止编辑,禁止删除\"},{\"M\":313,\"A\":\"\"},{\"M\":314,\"A\":\"\"},{\"M\":315,\"A\":\"\"},{\"M\":316,\"A\":\"\"},{\"M\":317,\"A\":\"\"},{\"M\":318,\"A\":\"\"},{\"M\":319,\"A\":\"\"},{\"M\":320,\"A\":\"\"}]', '2'), ('56', '稽查人员', '', '0', '0', '0', '[]', '2'), ('57', '弥勒南监测中心管理员', '', '0', '0', '0', '[{\"M\":4,\"A\":\"\"},{\"M\":7,\"A\":\"\"},{\"M\":5,\"A\":\"\"},{\"M\":6,\"A\":\"\"},{\"M\":41,\"A\":\"\"},{\"M\":264,\"A\":\"\"},{\"M\":265,\"A\":\"\"},{\"M\":266,\"A\":\"\"},{\"M\":271,\"A\":\"\"},{\"M\":270,\"A\":\"\"},{\"M\":274,\"A\":\"\"},{\"M\":275,\"A\":\"\"},{\"M\":279,\"A\":\"\"},{\"M\":283,\"A\":\"\"},{\"M\":281,\"A\":\"\"},{\"M\":284,\"A\":\"\"},{\"M\":285,\"A\":\"\"},{\"M\":295,\"A\":\"\"},{\"M\":294,\"A\":\"\"},{\"M\":296,\"A\":\"\"},{\"M\":297,\"A\":\"\"},{\"M\":298,\"A\":\"\"},{\"M\":307,\"A\":\"\"},{\"M\":308,\"A\":\"\"},{\"M\":309,\"A\":\"\"},{\"M\":312,\"A\":\"\"},{\"M\":313,\"A\":\"\"},{\"M\":314,\"A\":\"\"},{\"M\":315,\"A\":\"\"},{\"M\":316,\"A\":\"\"},{\"M\":317,\"A\":\"\"},{\"M\":318,\"A\":\"\"},{\"M\":319,\"A\":\"\"},{\"M\":320,\"A\":\"\"},{\"M\":321,\"A\":\"\"},{\"M\":322,\"A\":\"\"}]', '2');
COMMIT;

-- ----------------------------
--  Table structure for `IframeSystemModule`
-- ----------------------------
DROP TABLE IF EXISTS `IframeSystemModule`;
CREATE TABLE `IframeSystemModule` (
  `ModuleID` bigint(20) NOT NULL,
  `Name` varchar(50) DEFAULT NULL,
  `URL` varchar(200) DEFAULT NULL,
  `UrlGoModuleID` bigint(20) DEFAULT NULL,
  `ParentID` bigint(20) DEFAULT NULL,
  `Sort` int(11) NOT NULL,
  `IsParent` int(11) NOT NULL,
  `Icon` varchar(50) DEFAULT NULL,
  `Able` varchar(200) DEFAULT NULL,
  `IsShowInMenu` int(11) NOT NULL,
  `Remark` varchar(100) DEFAULT NULL,
  `IsShowLeftMenu` int(11) DEFAULT '1' COMMENT '激活后，是否显示左边菜单栏',
  PRIMARY KEY (`ModuleID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
--  Records of `IframeSystemModule`
-- ----------------------------
BEGIN;
INSERT INTO `IframeSystemModule` VALUES ('1', '系统模块设置', '/manage/System/SystemModule', '0', '7', '7', '0', 'cube', '', '2', '配置系统中可用的功能模块', '1'), ('2', '参数设置', '', '-1', '7', '2', '1', 'bonfire', '', '2', '', '1'), ('4', '系统用户', '', '-1', '7', '5', '1', 'ios-people', '', '2', '', '1'), ('5', '系统角色', '', '41', '7', '6', '1', 'ios-barcode-outline', '', '2', '', '1'), ('6', '角色设置', '/Manage/System/Rule/Edit', '0', '5', '1', '0', 'icon-note', '', '3', '', '1'), ('7', '系统管理', '', '-1', '0', '0', '1', 'wrench', '', '1', '', '1'), ('41', '角色管理', '/manage/System/Rule/Manage', '0', '5', '0', '0', 'icon-list', '禁止编辑 禁止删除', '3', '', '1'), ('264', '查询', '/manage/system/admin-user/manage', '0', '4', '0', '0', '', '禁止编辑 禁止删除', '3', '', '1'), ('265', '编辑', '/manage/system/admin-user/Edit', '0', '4', '1', '0', '', '', '3', '', '1'), ('266', '组织结构设置', '/Manage/System/OrgStruct/Manage', '0', '7', '4', '0', 'ios-list', '', '2', '', '1'), ('272', '查询', '/Manage/System/Params/Manage', '0', '2', '1', '0', '', '禁止编辑 禁止删除', '3', '', '1'), ('273', '编辑', '/Manage/System/Params/Edit', '0', '2', '2', '0', '', '', '3', '', '1'), ('281', '基础数据', '', '-1', '7', '3', '1', 'ios-ionic-outline', '', '2', '', '1'), ('283', '货物类型7', '/manage/system/IframeDict/Goods?dictname=货物类型', '0', '281', '1', '0', 'anticon anticon-bulb', '', '2', '', '1'), ('284', '异常情况类型', '/manage/system/IframeDict/Exception?dictname=异常情况类型', '0', '281', '2', '0', 'anticon anticon-question-circle-o', '', '2', '', '1'), ('285', '车辆类型', '/manage/system/IframeDict/CarType?dictname=车辆类型', '0', '281', '0', '0', 'anticon anticon-car', '', '2', '', '1'), ('310', '班次', '/manage/system/IframeDict/Classes?dictname=班次', '0', '281', '3', '0', 'anticon anticon-solution', '', '2', '', '1'), ('311', '组织结构类型', '/manage/system/IframeDict/OrgStructType?dictname=组织结构类型', '0', '281', '5', '0', 'anticon anticon-tag-o', '', '2', 'OrgStructType', '1'), ('313', '路段', '/manage/system/IframeDict/RoadSection?dictname=路段', '0', '281', '4', '0', 'anticon anticon-flag', '', '2', '', '1'), ('317', '稽查记录审核失败的原因', '/manage/system/IframeDict/AdoptInfoAuditWrongCause?dictname=稽查记录审核失败的原因', '0', '281', '6', '0', 'anticon anticon-frown', '', '2', '', '1'), ('318', '公告', '', '-1', '7', '0', '1', 'android-notifications', '', '2', '', '1'), ('319', '公告管理', '/Manage/System/Notice/Manage', '0', '318', '1', '0', '', '禁止编辑 禁止删除', '3', '', '1'), ('320', '公告编辑', '/Manage/System/Notice/Edit', '0', '318', '2', '0', '', '', '3', '', '1'), ('339', '微信公众号', '', '-1', '0', '3', '1', 'social-whatsapp', '', '1', '', '1'), ('340', '公众号管理', '/Manage/Weixin/manage', '0', '339', '1', '0', '', '', '2', '', '0'), ('341', '图文信息', '', '0', '7', '1', '1', 'ios-paper', '', '2', '', '1'), ('342', '图文信息分类', '/manage/system/IframeDict/ArticleLabel?dictname=图文信息分类', '0', '341', '1', '0', '', '', '2', '', '1'), ('343', '图文信息管理', '/Manage/Article/Manage', '0', '341', '2', '0', '', '禁止编辑 禁止删除', '2', '', '1');
COMMIT;

-- ----------------------------
--  Table structure for `IframeTabelID`
-- ----------------------------
DROP TABLE IF EXISTS `IframeTabelID`;
CREATE TABLE `IframeTabelID` (
  `TabelName` varchar(50) NOT NULL COMMENT '表名称',
  `IDValue` bigint(20) DEFAULT '0' COMMENT '表ID值',
  PRIMARY KEY (`TabelName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
--  Records of `IframeTabelID`
-- ----------------------------
BEGIN;
INSERT INTO `IframeTabelID` VALUES ('AppSystemModule', '5'), ('IframeDict', '12'), ('IframeOrgStruct', '8'), ('IframeSystemModule', '343'), ('OrgSystemModule', '29');
COMMIT;

-- ----------------------------
--  Table structure for `IframeUser`
-- ----------------------------
DROP TABLE IF EXISTS `IframeUser`;
CREATE TABLE `IframeUser` (
  `UserID` int(11) NOT NULL AUTO_INCREMENT,
  `UserName` varchar(50) DEFAULT NULL,
  `UserRealName` varchar(50) DEFAULT NULL,
  `UserJobNum` varchar(11) DEFAULT NULL COMMENT '工号',
  `UserPwd` varchar(50) DEFAULT NULL,
  `UserMobilePhone` varchar(15) DEFAULT NULL,
  `UserRule` varchar(50) DEFAULT NULL,
  `UserLoginIp` varchar(50) DEFAULT NULL,
  `UserPingYin` varchar(50) DEFAULT NULL,
  `UserCreatetime` bigint(20) DEFAULT NULL,
  `UserLoginTime` bigint(20) DEFAULT NULL,
  `UserIsSuper` int(11) DEFAULT '0' COMMENT '是否是超级管理员',
  `UserIsOnline` tinyint(4) DEFAULT '0' COMMENT '是否在线',
  `UserIsDel` tinyint(4) DEFAULT '0' COMMENT '是否被删除',
  `UserOrgStructID` int(11) DEFAULT '0' COMMENT '组织结构ID',
  PRIMARY KEY (`UserID`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
--  Records of `IframeUser`
-- ----------------------------
BEGIN;
INSERT INTO `IframeUser` VALUES ('1', 'admin', '超级管理员', '999999', 'tlr6jUSFkbcz1UZf5Yq+zg==', '13759496259', ',-9999,', '127.0.0.1', 'CJGLY', '1412598693', '0', '1', '0', '0', '0'), ('18', null, '中心1管理', '000003', '4QrcOUm6Wau+VuBX8g+IPg==', '123', ',50,', '', '', '1490858625', '1490858625', '0', '0', '0', '2'), ('19', null, '站长1号', '000031', '4QrcOUm6Wau+VuBX8g+IPg==', '12312111', ',49,', '', '', '1490858677', '1490858677', '0', '0', '0', '1'), ('20', null, 'App测试用户', '100', '4QrcOUm6Wau+VuBX8g+IPg==', '13800138002', ',56,', '', '', '1491544687', '1491544687', '0', '0', '0', '1'), ('21', null, '0号管理员', '000000', '4QrcOUm6Wau+VuBX8g+IPg==', '0000', '57', '', '', '1492759053', '1492759053', '0', '0', '0', '2'), ('22', null, '超级管理员', '111111', '4QrcOUm6Wau+VuBX8g+IPg==', '000', ',57,', null, null, '1492759053', '1492759053', '0', '0', '1', '13'), ('23', null, '11', '22', '4QrcOUm6Wau+VuBX8g+IPg==', '22', '49', null, null, '1506594495', '1506594495', '0', '0', '0', '13');
COMMIT;

-- ----------------------------
--  Table structure for `Notice`
-- ----------------------------
DROP TABLE IF EXISTS `Notice`;
CREATE TABLE `Notice` (
  `N_ID` int(11) NOT NULL AUTO_INCREMENT,
  `N_Title` varchar(255) DEFAULT '' COMMENT '标题',
  `N_Content` text COMMENT '内容',
  `N_IsTop` smallint(1) DEFAULT '0' COMMENT '是否置顶',
  `N_Info` varchar(255) DEFAULT '' COMMENT '简介',
  `N_TargetOrgStructIDs` varchar(255) DEFAULT '' COMMENT '接收公告的组织接口ID串，为空为全部接收',
  `N_CreateTime` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`N_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;

-- ----------------------------
--  Records of `Notice`
-- ----------------------------
BEGIN;
INSERT INTO `Notice` VALUES ('4', '测试数据不要删除', '测试数据不要删除', '1', '测试数据不要删除测试数据不要删除测试数据不要删除', ',13,', '2017-04-18 14:21:26'), ('10', ' 诶我去二群', '额外全额', '0', '请嗯无群', ',10,9,5,', '2017-04-17 22:21:47'), ('11', '的是多少的方式', '风度仕服饰的', '1', 'DVD的的', ',8,', '2017-04-17 22:24:39'), ('12', '问问', '二维翁无', '0', '曲儿无', ',5,', '2017-04-18 11:19:38'), ('13', '这是一个测试', 'If&nbsp;you&nbsp;don&#39;t&nbsp;specify&nbsp;noGlobal&nbsp;then&nbsp;the&nbsp;globally&nbsp;exported&nbsp;moment&nbsp;will&nbsp;print&nbsp;a&nbsp;deprecation&nbsp;warning.&nbsp;From&nbsp;next&nbsp;major&nbsp;release&nbsp;you&#39;ll&nbsp;have&nbsp;to&nbsp;export&nbsp;it&nbsp;yourself&nbsp;if&nbsp;you&nbsp;want&nbsp;that&nbsp;behavior.<br><br>For&nbsp;version&nbsp;2.5.x,&nbsp;in&nbsp;case&nbsp;you&nbsp;use&nbsp;other&nbsp;plugins&nbsp;that&nbsp;rely&nbsp;on&nbsp;Moment&nbsp;but&nbsp;are&nbsp;not&nbsp;AMD-compatible&nbsp;you&nbsp;may&nbsp;need&nbsp;to&nbsp;add&nbsp;wrapShim:&nbsp;true&nbsp;to&nbsp;your&nbsp;r.js&nbsp;config.<br><br>Note:&nbsp;To&nbsp;allow&nbsp;moment.js&nbsp;plugins&nbsp;to&nbsp;be&nbsp;loaded&nbsp;in&nbsp;requirejs&nbsp;environments,&nbsp;moment&nbsp;is&nbsp;created&nbsp;as&nbsp;a&nbsp;named&nbsp;module.&nbsp;Because&nbsp;of&nbsp;this,&nbsp;moment&nbsp;must&nbsp;be&nbsp;loaded&nbsp;exactly&nbsp;as&nbsp;as&nbsp;&quot;moment&quot;,&nbsp;using&nbsp;paths&nbsp;to&nbsp;determine&nbsp;the&nbsp;directory.&nbsp;Requiring&nbsp;moment&nbsp;with&nbsp;a&nbsp;path&nbsp;like&nbsp;&quot;vendor\\moment&quot;&nbsp;will&nbsp;return&nbsp;undefined.<br><br>Note:&nbsp;From&nbsp;version&nbsp;2.9.0&nbsp;moment&nbsp;exports&nbsp;itself&nbsp;as&nbsp;an&nbsp;anonymous&nbsp;module,&nbsp;so&nbsp;if&nbsp;you&#39;re&nbsp;using&nbsp;only&nbsp;the&nbsp;core&nbsp;(no&nbsp;locales&nbsp;/&nbsp;plugins),&nbsp;then&nbsp;you&nbsp;don&#39;t&nbsp;need&nbsp;config&nbsp;if&nbsp;you&nbsp;put&nbsp;it&nbsp;on&nbsp;a&nbsp;non-standard&nbsp;location.', '0', '这是一个测试', ',8,12,', '2017-04-18 16:25:38');
COMMIT;

-- ----------------------------
--  Table structure for `StatisticsOption`
-- ----------------------------
DROP TABLE IF EXISTS `StatisticsOption`;
CREATE TABLE `StatisticsOption` (
  `SO_ID` char(37) NOT NULL,
  `SO_ChartType` char(10) DEFAULT NULL COMMENT '报表类型',
  `SO_Title` varchar(50) DEFAULT NULL COMMENT '标题',
  `SO_Info` varchar(100) DEFAULT NULL COMMENT '备注',
  `SO_IsShowInMenu` smallint(6) DEFAULT '0' COMMENT '是否在导航菜单中显示',
  `SO_Target` char(10) DEFAULT NULL COMMENT '统计对象',
  `SO_X_Type` varchar(50) DEFAULT NULL COMMENT 'X轴类型',
  `SO_Y_Type` varchar(50) DEFAULT NULL COMMENT 'Y轴类型',
  `SO_Category` text COMMENT '统计方式',
  `SO_Legend` text COMMENT '数据分类',
  `SO_CreateTime` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`SO_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;

-- ----------------------------
--  Table structure for `WeixinApp`
-- ----------------------------
DROP TABLE IF EXISTS `WeixinApp`;
CREATE TABLE `WeixinApp` (
  `WX_ID` int(11) NOT NULL AUTO_INCREMENT,
  `WX_AppID` char(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '应用ID',
  `WX_AppName` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '应用名称',
  `WX_AppType` tinyint(4) DEFAULT '0' COMMENT '应用类型',
  `WX_AppSecret` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '应用密钥',
  `WX_AppToken` varchar(16) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '微信访问App服务端的令牌',
  `WX_AccessToken` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '访问微信服务器的令牌2小时过期',
  `WX_JsApi_Ticket` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '调用JSAPI的Ticket2小时过期',
  `WX_AccessToken_ExpiresTime` int(11) DEFAULT '0' COMMENT '过期时间',
  `WX_JsApi_Ticket_ExpiresTime` int(11) DEFAULT '0' COMMENT '过期时间',
  `WX_CreateTime` datetime DEFAULT NULL COMMENT '创建时间',
  `WX_UpdateTime` datetime DEFAULT NULL COMMENT '更新令牌时间',
  `WX_EncodingAESKey` varchar(43) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '消息加密密钥由43位字符组成',
  `WX_Menu` text COLLATE utf8mb4_unicode_ci COMMENT '自定义菜单',
  `WX_WXNum` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '微信号',
  `WX_IsActive` tinyint(6) DEFAULT '0' COMMENT '是否激活',
  `WX_IsConcernAutoRequest` tinyint(6) DEFAULT '0' COMMENT '是否开启关注时自动回复',
  `WX_IsMsgAutoRequest` tinyint(6) DEFAULT '0' COMMENT '是否开启收到消息自动回复',
  `WX_ConcernAutoRequstContent` text COLLATE utf8mb4_unicode_ci COMMENT '关注时自动回复的内容',
  `WX_MsgAutoRequestContent` text COLLATE utf8mb4_unicode_ci COMMENT '收到消息时自动回复的内容',
  `WX_PartnersID` int(11) DEFAULT '0' COMMENT '合作伙伴ID',
  `WX_MchID` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '微信支付分配的商户号',
  `WX_CommercialName` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '商户名称',
  `WX_PayPwd` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '微信支付API密钥',
  PRIMARY KEY (`WX_ID`),
  UNIQUE KEY `NewIndex1` (`WX_AppID`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
--  Records of `WeixinApp`
-- ----------------------------
BEGIN;
INSERT INTO `WeixinApp` VALUES ('10', 'wx811b2730c47cd27c', '法制在线', '2', '77FCEC6DFFB1448E9CA4AC6CB89C25EC', '48194989101549bc', 'bfUUzc2ik0XYnTNi9ggSglYDDGwvb_Fd3E8Qd-AFGNFTTv_VgtbuMtNRLllEm7XUst24FlkdvuwmVzpAxZTsDQxOzc23b6Hdz67Pqa4AmAIviHoEmYK7Q3PWjtFTvITTVITiABADQB', 'kgt8ON7yVITDhtdwci0qedUOg12FdmFFRa4WtA7_8cvR5W49jHKLHsMS0pMkKHLFtOJjCLHCVjGUNwyY5ST-cg', '0', '0', '2016-11-04 21:13:17', '2016-11-17 00:59:18', '2aeIECi5BRGrnUgOI9HYSXfaHQEwvWViye2UPydfAEF', '', 'cnyn124', '0', '0', '0', '', '', '0', '1247706801', '法治在线', '77FCEC6DFFB1448E9CA4AC6CB89C25EC');
COMMIT;

-- ----------------------------
--  View structure for `v_caradoptinfo`
-- ----------------------------
DROP VIEW IF EXISTS `v_caradoptinfo`;
CREATE ALGORITHM=UNDEFINED DEFINER=`remote`@`%` SQL SECURITY DEFINER VIEW `v_caradoptinfo` AS select `caradoptinfo`.`AC_ID` AS `AC_ID`,`caradoptinfo`.`AC_CarNum` AS `AC_CarNum`,`caradoptinfo`.`AC_CarType` AS `AC_CarType`,`caradoptinfo`.`AC_CarWide` AS `AC_CarWide`,`caradoptinfo`.`AC_CarLength` AS `AC_CarLength`,`caradoptinfo`.`AC_CarHeight` AS `AC_CarHeight`,`caradoptinfo`.`AC_CarVolume` AS `AC_CarVolume`,`caradoptinfo`.`AC_CarWeight` AS `AC_CarWeight`,`caradoptinfo`.`AC_Tonnage` AS `AC_Tonnage`,`caradoptinfo`.`AC_CarDensity` AS `AC_CarDensity`,`caradoptinfo`.`AC_CarImg` AS `AC_CarImg`,`caradoptinfo`.`AC_InsertUseID` AS `AC_InsertUseID`,`caradoptinfo`.`AC_AuditingType` AS `AC_AuditingType`,`caradoptinfo`.`AC_AuditingMonitorID` AS `AC_AuditingMonitorID`,`caradoptinfo`.`AC_AuditingMasterID` AS `AC_AuditingMasterID`,`caradoptinfo`.`AC_IsBlackCar` AS `AC_IsBlackCar`,`caradoptinfo`.`AC_EntryTime` AS `AC_EntryTime`,`caradoptinfo`.`AC_ExportTime` AS `AC_ExportTime`,`caradoptinfo`.`AC_CreateTime` AS `AC_CreateTime`,`caradoptinfo`.`AC_AuditingTime` AS `AC_AuditingTime`,`caradoptinfo`.`AC_RepeatAuditionTime` AS `AC_RepeatAuditionTime`,`caradoptinfo`.`AC_OrgStructID` AS `AC_OrgStructID`,`caradoptinfo`.`AC_CargoType` AS `AC_CargoType`,`caradoptinfo`.`AC_Charges` AS `AC_Charges`,`caradoptinfo`.`AC_Classes` AS `AC_Classes`,`caradoptinfo`.`AC_Remark` AS `AC_Remark`,`caradoptinfo`.`AC_IsSealing` AS `AC_IsSealing`,`iframeuser`.`UserRealName` AS `OpteratorName`,`iframeuser`.`UserJobNum` AS `OperatorJobNum`,`User3`.`UserRealName` AS `MonitorName`,`User3`.`UserJobNum` AS `MonitorJobNum`,`User2`.`UserRealName` AS `MasterName`,`User2`.`UserJobNum` AS `MasterJobNum`,`caradoptinfo`.`AC_IDPhoto` AS `AC_IDPhoto`,`caradoptinfo`.`AC_IsOk` AS `AC_IsOk`,`caradoptinfo`.`AC_IntrySerialNum` AS `AC_IntrySerialNum`,`caradoptinfo`.`AC_IntryStationName` AS `AC_IntryStationName`,`caradoptinfo`.`AC_IntryRoadName` AS `AC_IntryRoadName`,`caradoptinfo`.`AC_IntryCenterName` AS `AC_IntryCenterName`,`caradoptinfo`.`AC_ExportSerialNum` AS `AC_ExportSerialNum`,`caradoptinfo`.`AC_ExportStationName` AS `AC_ExportStationName`,`caradoptinfo`.`AC_ExportRoadName` AS `AC_ExportRoadName`,`caradoptinfo`.`AC_ExportCenterName` AS `AC_ExportCenterName`,`caradoptinfo`.`AC_Mileage` AS `AC_Mileage`,`caradoptinfo`.`AC_CarClass` AS `AC_CarClass`,`caradoptinfo`.`AC_IsSync` AS `AC_IsSync`,`caradoptinfo`.`AC_AbnormalType` AS `AC_AbnormalType`,`caradoptinfo`.`AC_GoodsImg` AS `AC_GoodsImg`,`caradoptinfo`.`AC_AuditWrongCause` AS `AC_AuditWrongCause`,`caradoptinfo`.`AC_AuditWrongCauseRemark` AS `AC_AuditWrongCauseRemark` from (((`caradoptinfo` left join `iframeuser` on((`caradoptinfo`.`AC_InsertUseID` = `iframeuser`.`UserID`))) left join `iframeuser` `User2` on((`caradoptinfo`.`AC_AuditingMasterID` = `User2`.`UserID`))) left join `iframeuser` `User3` on((`caradoptinfo`.`AC_AuditingMonitorID` = `User3`.`UserID`)));

-- ----------------------------
--  View structure for `v_carblackinfo`
-- ----------------------------
DROP VIEW IF EXISTS `v_carblackinfo`;
CREATE ALGORITHM=UNDEFINED DEFINER=`remote`@`%` SQL SECURITY DEFINER VIEW `v_carblackinfo` AS select `carblackinfo`.`CB_ID` AS `CB_ID`,`carblackinfo`.`CB_CarNum` AS `CB_CarNum`,`carblackinfo`.`CB_BlackReason` AS `CB_BlackReason`,`carblackinfo`.`CB_IsExamine` AS `CB_IsExamine`,`carblackinfo`.`CB_SubmiterID` AS `CB_SubmiterID`,`carblackinfo`.`CB_OperatorID` AS `CB_OperatorID`,`carblackinfo`.`CB_IllegalNum` AS `CB_IllegalNum`,`carblackinfo`.`CB_OrgStructID` AS `CB_OrgStructID`,`carblackinfo`.`CB_CreactTime` AS `CB_CreactTime`,`iframeorgstruct`.`OS_Name` AS `OS_Name`,`iframeorgstruct`.`OS_ID` AS `OS_ID`,`OperatorUser`.`UserID` AS `UserID`,`SubmitUser`.`UserRealName` AS `submitUserName`,`SubmitUser`.`UserJobNum` AS `submitJobNum`,`OperatorUser`.`UserRealName` AS `operatorRealName`,`OperatorUser`.`UserJobNum` AS `operatorJobNum`,`carblackinfo`.`CB_RunAwayCount` AS `CB_RunAwayCount` from (((`carblackinfo` left join `iframeorgstruct` on((`carblackinfo`.`CB_OrgStructID` = `iframeorgstruct`.`OS_ID`))) left join `iframeuser` `OperatorUser` on((`carblackinfo`.`CB_OperatorID` = `OperatorUser`.`UserID`))) left join `iframeuser` `SubmitUser` on((`carblackinfo`.`CB_SubmiterID` = `SubmitUser`.`UserID`)));

-- ----------------------------
--  View structure for `v_carblackrunawaylog`
-- ----------------------------
DROP VIEW IF EXISTS `v_carblackrunawaylog`;
CREATE ALGORITHM=UNDEFINED DEFINER=`remote`@`%` SQL SECURITY DEFINER VIEW `v_carblackrunawaylog` AS select `carblackrunawaylog`.`CBRL_ID` AS `CBRL_ID`,`carblackrunawaylog`.`CBRL_CarNum` AS `CBRL_CarNum`,`carblackrunawaylog`.`CBRL_Tollstation` AS `CBRL_Tollstation`,`carblackrunawaylog`.`CBRL_OrgStructID` AS `CBRL_OrgStructID`,`carblackrunawaylog`.`CBRL_SubmiterID` AS `CBRL_SubmiterID`,`carblackrunawaylog`.`CBRL_CreateTime` AS `CBRL_CreateTime`,`iframeuser`.`UserRealName` AS `SubmiterUserRealName` from (`carblackrunawaylog` left join `iframeuser` on((`carblackrunawaylog`.`CBRL_SubmiterID` = `iframeuser`.`UserID`)));

SET FOREIGN_KEY_CHECKS = 1;
